update role_auth set HAS_RIGHT = 0 where AUTH_TYPE = 8 and ROLE_ID in (10,11,12) and PROCESS_METHOD = 1
go
update role_auth set HAS_RIGHT = 0 where AUTH_TYPE = 9 and ROLE_ID in (10) and PROCESS_METHOD = 1
go
insert into role_auth(AUTH_TYPE,ROLE_ID,PROCESS_METHOD,HAS_RIGHT) values (9,10,3,1)
go